SELECT Id FROM new_searchtable
where (town like 'Lyme' and state='NH'
or town like 'Enfield' and state='NH'
or town like 'Lebanon' and state='NH'
or town like 'Hanover' and state='NH'
or town like 'Plainfield'and state='NH'
or town like 'Cornish'and state='NH'
or town like 'Grantham'and state='NH'
or town like 'Eastman'and state='NH'
or town like 'Dorchester'and state='NH' )
and list_price > '700000' and (type = 'R' or type ='O')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 15
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:This 4 bedroom, 3.5 bath contemporary is beautifully situated on a corner 1.97+/- acre lot in the village of Etna in Hanover. The main floor features an open cherry kitchen with granite counters, lots of storage and light filled dining area that leads to a brand new deck. The living room with it's cozy woodstove and soaring catherdral ceilings is perfect for gathering and entertaining and the primary suite with a walk through closet and a full bath is nicely nestled on the backside of the home. Upstairs features 3 bedrooms, a full bath and a loft space overlooking the living room. In the walkout basement you have a mudroom off the 2 car garage, big family room, 3/4 bath, laundry and a bonus room for exercise equipment and all your outdoor gear. Love to bike and hike?! Numerous trails within super close proximity - Trescott trails, AT and more! A great house in a great location! Delayed showings start on Saturday, March 29th at the Open House from 11:00-1:00.
Description:Welcome to 108 Blueberry Hill Drive, a lovingly updated ranch conveniently located only? 15 minutes from DHMC, Dartmouth College, AND 12A shopping. The main floor? welcomes you with an updated kitchen, spacious living and dining rooms, and a clever? cubby/pantry area. The south end of the main floor contains the primary bedroom with? ensuite 3/4 bath, two additional bedrooms and a full bathroom. Both bathrooms on the? main floor were recently updated. Downstairs is an additional bedroom and bathroom, a? family room with wood stove, an office/craft room, a laundry room/workshop, and storage? galore.? Outside are hundreds of flower bulbs, mature flower beds with deer-resistant? perennials, and 300 square?feet of organic raised vegetable gardens. The fenced yard? allows dogs to run free or keeps chickens in-bounds. A new 3-cord woodshed is? conveniently located next to the basement door. Take in gorgeous sunsets while enjoying? meals on the Trex deck. New paint completes the exterior transformation.? Energy efficiency is a top priority. All newly-installed windows are Anderson 400 with Low-? E glass. Windows on the back of the house also contain a SunSmart coating to reduce? solar?gain. The 10 megawatt solar system has reduced energy bills to only a couple? hundred dollars per year. The wood stove combined with an efficient oil boiler keep the? house cozy. An electric heat pump hot water heater for domestic hot water and a Level-2? CCS EV charger.
Description:Sited on a southeast-facing ridge in the hills of Plainfield, this extraordinary estate seamlessly blends elegance, solitude, and natural beauty. The private 103 acres of pristine woodlands with multiple ponds, meandering hiking and riding trails, and views of local hills and distant mountains, offers the ultimate retreat while being just minutes from Dartmouth College, DHMC, I-89, and I-91. Its location provides both tranquility and convenient access to the best of the Upper Valley, Boston, and beyond. The residence is a unique fusion of Tuscan-inspired design, Italian elegance, and traditional New England craftsmanship. Recently renovated with meticulous attention to detail, the home features a sun-drenched, flexible floor plan with five spacious bedrooms, multiple additional spaces to use as you see fit, and a guest wing. The redesigned eat-in kitchen and breakfast nook showcase modern updates, while radiant heat, wood, and pellet stoves ensure cozy warmth. Notable features such as the observation tower provide unique spaces to relax, take in the spectacular views, and stargaze. The property is designed for both leisure and function and includes a 2-bay attached garage, 1-bay under, 3-bay detached barn, and more. There's ample space for your hobbies and all the gear. Whether exploring the trails, enjoying the ponds, or hosting in the expansive living spaces, this retreat delivers a lifestyle of unmatched serenity, privacy, luxury, and sophistication.
Description:Marvellous contemporary cape in move-in condition with fabulous gleaming hardwood floors throughout the main level. Open first floor has spacious kitchen, dining room, living room, mudroom, office and 1/2 bath/laundry. Second floor has 3 bedrooms, 2 full bathrooms. Separate suite, accessed from mudroom has large living room or home office, bedroom, and 3/4 bath. This residential neighborhood location makes for quick and easy commuting to the medical center, without driving through Hanover, or to the College. A great one! Showings start at Open House Saturday, Jan 4, 10am-12 and Sunday, Jan 5, 2-4pm
Description:A special opportunity to acquire a dramatic contemporary on 10+/- gorgeous acres, featuring Trout Brook, a swimming hole, and a magnificent waterfall. Located in the gorgeous hills of Lyme the house was created by architect Don Metz, an early pioneer of thoughtful sustainable design. Living room has dramatic windows, hardwood floors and cozy stove. The kitchen and dining room look out to a large year round sunroom from which you can see Trout Brook. First floor also has two offices, both with lovely views. Upstairs there are three bedrooms, one with a loft, and two full baths. A further finished space in the walkout lower level has a guest room or playroom and bath. And then there is the guest house, which has a complete apartment which you can use for guests or as a rental. This is a really great listing!